package com.zzxy.spring5.dao.impl;

import com.zzxy.spring5.dao.IAccountDao;

public class AccountDaoImpl extends JdbcDaoSupport implements IAccountDao {
    @Override
    public void out(String outer, int money) {
        this.getJdbcTemplate().update("update account set money = money - ? where username = ?",money,outer);

    }

    @Override
    public void in(String inner, int money) {
        this.getJdbcTemplate().update("update account set money = money + ? where username = ?",money,inner);
    }

    public void setDataSource(String dataSource) {
        this.dataSource= dataSource;
    }
//jdbctemplate
// BasicDataSource dataSource=new BasicDataSource();
// dataSource.setDriverClassName("com.mysql.cj.jdbc.Driver");
// dataSource.setUrl("jdbc:mysql://localhost:3306/spring34?serverTimezone=UTC");
// dataSource.setUsername("root");
// dataSource.setPassword("123456");
// JdbcTemplate jdbcTemplate=new JdbcTemplate(dataSource);
// jdbcTemplate.update("insert into t_user values (null,?,?)","zhangsan","123");
//// jdbcTemplate.update("update t_user set username = ? where id = ?","lisi",3);

}
